<html>

<style>
 {{{defaultstyle}}}
 body {padding: 10px 10px; font-family: Verdana}
 td, th {border: solid silver 1px; padding: 5px 5px}
 input { border: solid transparent 1px}
 p {cursor: pointer}
 p:hover {color: orange}
 h3 {color: #779}
</style>
<script type="passcript">

 procedure showorders;
 begin
  s:='<style>body{background: infobk} td, th {border: solid silver 1px; padding: 3px 3px} h3 {color: #779}
  </style>
  <h3>{{NAME}}</h3>
  <DATAPACKET width="500">
  <METADATA autosort="true">
   <FIELDS>
   <FIELD name="ORDERNO" caption="Order No" total="count(*)" width="10%"/>
    <FIELD name="SALEDATE" caption="Sale Date" width="10%"/>
    <FIELD name="SHIPDATE" caption="Ship Date" width="10%"/>
    <FIELD name="LASTNAME" caption="Employee" width="20%"/>
    <FIELD name="AMOUNTPAID" caption="Amount Paid" total="sum"  width="15%" format="# ### ##0.00"/>
   </FIELDS>
   <SQL>
    select o.orderno, cast(saledate as date) saledate, cast(shipdate as date) shipdate,
     paymentmethod, itemstotal, amountpaid, e.lastname
    from orders o
     join employee e on e.empno=o.empno
    where custno = ({{CUSTNO}})
    order by 1
   </SQL>
  </METADATA>
 </DATAPACKET>';

 s := RunHtReport(s, '<CONTEXT CUSTNO="'+this.Attr['custno']+'" NAME="'+this.Attr['name']+'"/>');
 document.control.ShowFloatHint(this, s, false);
 end;

</script>

<h3> Interactive hints <img onclick="htnotifyinfo('Click on a customer to view its orders')"
   width="16" src="_dialogicons/information"/> </h3>

<report-objects>
<object name="cust" sql="select * from customer order by company"/>
</report-objects>

{{#cust.ROWDATA}}
<p custno="{{CUSTNO}}" name="{{COMPANY}}" onclick="showorders()"><i class="fa fa-user"/>  {{COMPANY}}</p>
{{/cust.ROWDATA}}

</html>
